?? userdaoimpl.java
字號:
package test;
import java.sql.*;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
//操作員
public class UserDaoImpl{
private JDBConnection connection = null;
public UserDaoImpl() {
this.connection = new JDBConnection();
}
// 登陸操作
public String checkUser(String user)
{
String sql = "select user_mm from tb_user where user_num='" + user + "'";
try {
ResultSet rs = connection.executeQuery(sql);
if (rs.next())
{
return rs.getString(1);
}
}
catch (SQLException ex)
{
}
return null;
}
//插入操作
public void insertUser(String num,String mm,String name,String email,String tel)
{
String sql = "insert into tb_user values('"+num+"','"+mm+"','"+name+"','"+email+"','"+tel+"')";
connection.executeQuery(sql);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -