admin管理员组

文章数量:1532440

package BDO;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class Dao {

private static final String

DRIVER_CLASS =

"com.microsoft.sqlserver.jdbc.SQLServerDriver";

private static final String

DATABASE_URL =

"jdbc:sqlserver://localhost:1433;DatabaseName=fanyi";

private static final String

DATABASE_USRE = "sa";

private static final String

DATABASE_PASSWORD = "sa";

public static Connection

getConnection() {

Connection

dbConnection = null;

try {

Class.forName(DRIVER_CLASS);

dbConnection

= DriverManager.getConnection(DATABASE_URL,

DATABASE_USRE,

DATABASE_PASSWORD);

} catch

(Exception e) {

e.printStackTrace();

}

return

dbConnection;

}

public static void

closeConnection(Connection dbConnection) {

try {

if

(dbConnection != null &&

(!dbConnection.isClosed())) {

dbConnection.close();

}

} catch

(SQLException sqlEx) {

sqlEx.printStackTrace();

}

}

public static void

closeResultSet(ResultSet res) {

try {

if

(res != null) {

res.close();

res

= null;

}

} catch

(SQLException e) {

e.printStackTrace();

}

}

public static void

closeStatement(PreparedStatement pStatement) {

try {

if

(pStatement != null) {

pStatement.close();

pStatement

= null;

}

} catch

(SQLException e) {

e.printStackTrace();

}

}

}

package BDO;

public class huyi {

private String china;

private String english;

public String getChina() {

return china;

}

public void setChina(String china) {

this.china = china;

}

public String getEnglish() {

return english;

}

public void setEnglish(String english) {

this.english = english;

}

}

package java1;

import java.awt.Font;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import javax.swing.*;

import BDO.Dao;

import BDO.huyi;

public class Huyi implements ActionListener {

JFrame jf = new JFrame("单词翻译");

JLabel lb1 = new JLabel("英译汉");

JLabel lb2 = new JLabel("请输入英语");

JTextField text = new JTextField();

JButton b = new JButton("翻译");

public Huyi() {

jf.setLayout(null);

lb1.setFont((new Font("楷体",

Font.PLAIN, 35)));

lb1.setBounds(160, 40, 150,

60);

jf.add(lb1);

lb2.setFont((new Font("宋体",

Font.PLAIN, 25)));

lb2.setBounds(50, 150, 160,

30);

jf.add(lb2);

text.setFont((new Font("宋体",

Font.PLAIN, 25)));

text.setBounds(200, 150, 130,

30);

jf.add(text);

b.setFont((new Font("宋体",

Font.PLAIN, 25)));

b.setBounds(140, 240, 140,

30);

jf.add(b);

b.addActionListener(this);

jf.setSize(400, 400);

jf.setVisible(true);

}

public static void main(String[] args) {

new Huyi();

}

public void actionPerformed(ActionEvent e)

{

if

(e.getActionCommand().equals("翻译")) {

huyi china =

new huyi();

Connection

conn = null;

PreparedStatement

pstmt = null;

ResultSet rs

= null;

try {

conn

= Dao.getConnection();

String

str = "select china from huyi where english=?";

pstmt

= conn.prepareStatement(str);

pstmt.setString(1,

text.getText());

rs

= pstmt.executeQuery();

if

(rs.next()) {

String

mess = rs.getString(1);

JOptionPane.showMessageDialog(null,

mess, "翻译结果",

JOptionPane.INFORMATION_MESSAGE);

}

else {

JOptionPane.showMessageDialog(null,

"这个英语单词我不知道!", "错误信息",

JOptionPane.ERROR_MESSAGE);

text.setText("");

}

} catch

(Exception ee) {

ee.printStackTrace();

}

}

}

}

本文标签: 简单功能英汉翻译Java