How to insert the “logical and” (&) to MySQL database?
You may try to escape the “&” character, but it doesn’t work.
Database
Java code for connecting MS SQL Server by using SQL Server Authentication
First of all, You will need to add a jar file to your project library as SQL Server 2000 Driver for JDBC Service. My target is SQL Server 2000, it will require the jar file called “sqljdbc4.jar”. This is not supported on Microsoft website now, you can download it here. For other versions of SQL Server, here is the link of SQL Server 2000 Driver for JDBC Service.
The following is the code for connection MS SQL Server and select some records from a testing table.
Java connect MS SQL Server using windows authentication
To connect MS SQL Server using windows authentication, the first step is to setup ODBC. You can go to Control panel -> Administrative tools -> ODBC. Add a new DSN to connect MS SQL Server using windows authentication account following wizard setup. The second step is the similar with using SQL Server authentication. The only … Read more
Prototype of Java Database Class
Can we make a database connection class which allows us just change the configuration file, and then use the database? I did the prototype of this class which is very simple. But the idea is good, always use a very simple jar file to get setup database which can then do SQL query operations. package … Read more