主要用到:1.DBUtil 类,连接数据库的代码都在里边。
2. libs中的.jar包,着着非常重要,很多人忘记导入相应jar包导致找不到资源啥的。
3. AndroidManifest.xml中加权限
记得在AndroidManifest.xml中加入socket权限:
<uses-permission android:name="android.permission.INTERNET" />
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
2,3步不懂得可以参考:https://blog.csdn.net/na2609613672/article/details/82222795
DBUtil 类代码:
package com.monitorsys.seashell.myapp;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBUtil
{
private String name=null;
private String pass=null;
public DBUtil(String m,String p){
this.name=m;
this.pass=p;
}
private static Connection getSQLConnection(String ip, String user, String pwd, String db)
{
Connection con = null;
try
{
Class.forName("net.sourceforge.jtds.jdbc.Driver");
con = DriverManager.getConnection("jdbc:jtds:sqlserver://" + ip + ":1433/" + db + ";charset=utf8", user, pwd);
} catch (ClassNotFoundException e)
{
e.printStackTrace();
} catch (SQLException e)
{
e.printStackTrace();
}<