最近做了一个项目,客户有个需求,没有后台服务的情况下直接连接数据库;
多的不说了,直接上代码
public static Connection getSQLConnection(String ip, String user, String pwd, String db)
{
Connection con = null;
String portsNum=StaticParams.dataBasePortNumber;
try
{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + ip + ":"+portsNum+"/" + db, user, pwd);
} catch (ClassNotFoundException e)
{
e.printStackTrace();
con = null;
} catch (SQLException e)
{
con = null;
e.printStackTrace();
}
return con;
}
插入
public static String insertAppNumberCodeData(String OutCheckNote){
String result = "";
Connect