?? product.java
字號:
package dal;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class Product
{
//添加員工信息
public static boolean add(model.Product m)
{
boolean b=false;
try
{
String sql="insert into Product(P_name,P_price,P_remark) values(?,?,?)";
PreparedStatement ps=SQLHelper.getConn().prepareStatement(sql);
ps.setString(1,m.P_name);
ps.setDouble(2,m.P_price);
ps.setString(3,m.P_remark);
b=SQLHelper.executeUpdate(ps);
}
catch(SQLException e)
{
System.out.println (e);
}
return b;
}
//刪除員工信息
public static boolean delete(int id)
{
boolean b=false;
try
{
String sql="delete from Product where P_id=?";
PreparedStatement ps=SQLHelper.getConn().prepareStatement(sql);
ps.setInt(1,id);
b=SQLHelper.executeUpdate(ps);
}
catch(SQLException e)
{
System.out.println (e);
}
return b;
}
//更新員工信息
public static boolean update(model.Product m)
{
boolean b=false;
try
{
String sql="update Product set P_name=?,P_price=?,P_remark=? where P_id=?";
PreparedStatement ps=SQLHelper.getConn().prepareStatement(sql);
ps.setString(1,m.P_name);
ps.setDouble(2,m.P_price);
ps.setString(3,m.P_remark);
ps.setInt(4,m.P_id);
System.out.println ("a");
b=SQLHelper.executeUpdate(ps);
}
catch(SQLException e)
{
System.out.println (e);
}
return b;
}
//查詢員工信息
public static ResultSet list(String strWhere)
{
ResultSet rs=null;
try
{
String sql="select * from Product";
if(strWhere!="")
{
sql+=strWhere;
}
PreparedStatement ps=SQLHelper.getConn().prepareStatement(sql);
rs=SQLHelper.executeQuery(ps);
}
catch(SQLException e)
{
System.out.println (e);
}
return rs;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -